Date & Time

SELECT NOW();
/* 2023-12-07 15:30:32.543779+00 */

SELECT NOW()::DATE;
/* 2023-12-07 */

SELECT NOW()::TIME;
/* 15:31:51.826372 */